package SQLQrys;

public class QrysLancha {
		
	public String selectLanchas() {
		return "select * from lancha where id_partida = ?";
	}
	
	public String insertLancha() {
		return "insert into lancha(id,id_partida,pto_ini_x,pto_ini_y,vida) values (?,?,?,?,?)";
	}
	
	public String selectCount(){
		return "select count(*) as cnt from lancha where id_partida = ?";
	}
	
	public String updateLancha() {
		return "update lancha set pto_ini_x = ?, pto_ini_y= ?, vida = ? where id = ? and id_partida = ? ";
	}
}
